﻿USE [DotConference]
GO
/****** Object:  ForeignKey [FK_ActeConference_Editeur]    Script Date: 04/27/2009 20:49:03 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ActeConference_Editeur]') AND parent_object_id = OBJECT_ID(N'[dbo].[ActeConference]'))
ALTER TABLE [dbo].[ActeConference] DROP CONSTRAINT [FK_ActeConference_Editeur]
GO
/****** Object:  ForeignKey [FK_Article_Conference1]    Script Date: 04/27/2009 20:49:05 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Article_Conference1]') AND parent_object_id = OBJECT_ID(N'[dbo].[Article]'))
ALTER TABLE [dbo].[Article] DROP CONSTRAINT [FK_Article_Conference1]
GO
/****** Object:  ForeignKey [FK_Article_Participant]    Script Date: 04/27/2009 20:49:05 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Article_Participant]') AND parent_object_id = OBJECT_ID(N'[dbo].[Article]'))
ALTER TABLE [dbo].[Article] DROP CONSTRAINT [FK_Article_Participant]
GO
/****** Object:  ForeignKey [FK_Inscription_Conference]    Script Date: 04/27/2009 20:49:11 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Inscription_Conference]') AND parent_object_id = OBJECT_ID(N'[dbo].[Inscription]'))
ALTER TABLE [dbo].[Inscription] DROP CONSTRAINT [FK_Inscription_Conference]
GO
/****** Object:  ForeignKey [FK_Inscription_Participant]    Script Date: 04/27/2009 20:49:11 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Inscription_Participant]') AND parent_object_id = OBJECT_ID(N'[dbo].[Inscription]'))
ALTER TABLE [dbo].[Inscription] DROP CONSTRAINT [FK_Inscription_Participant]
GO
/****** Object:  ForeignKey [FK_Presentation_Session]    Script Date: 04/27/2009 20:49:18 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Presentation_Session]') AND parent_object_id = OBJECT_ID(N'[dbo].[Presentation]'))
ALTER TABLE [dbo].[Presentation] DROP CONSTRAINT [FK_Presentation_Session]
GO
/****** Object:  ForeignKey [FK_RapportEvaluation_Article]    Script Date: 04/27/2009 20:49:20 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RapportEvaluation_Article]') AND parent_object_id = OBJECT_ID(N'[dbo].[RapportEvaluation]'))
ALTER TABLE [dbo].[RapportEvaluation] DROP CONSTRAINT [FK_RapportEvaluation_Article]
GO
/****** Object:  ForeignKey [FK_RapportEvaluation_Participant]    Script Date: 04/27/2009 20:49:20 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RapportEvaluation_Participant]') AND parent_object_id = OBJECT_ID(N'[dbo].[RapportEvaluation]'))
ALTER TABLE [dbo].[RapportEvaluation] DROP CONSTRAINT [FK_RapportEvaluation_Participant]
GO
/****** Object:  ForeignKey [FK_REL_Article_ActeConference_ActeConference]    Script Date: 04/27/2009 20:49:21 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_REL_Article_ActeConference_ActeConference]') AND parent_object_id = OBJECT_ID(N'[dbo].[REL_Article_ActeConference]'))
ALTER TABLE [dbo].[REL_Article_ActeConference] DROP CONSTRAINT [FK_REL_Article_ActeConference_ActeConference]
GO
/****** Object:  ForeignKey [FK_REL_Article_ActeConference_Article]    Script Date: 04/27/2009 20:49:21 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_REL_Article_ActeConference_Article]') AND parent_object_id = OBJECT_ID(N'[dbo].[REL_Article_ActeConference]'))
ALTER TABLE [dbo].[REL_Article_ActeConference] DROP CONSTRAINT [FK_REL_Article_ActeConference_Article]
GO
/****** Object:  ForeignKey [FK_Session_Conference]    Script Date: 04/27/2009 20:49:24 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Session_Conference]') AND parent_object_id = OBJECT_ID(N'[dbo].[Session]'))
ALTER TABLE [dbo].[Session] DROP CONSTRAINT [FK_Session_Conference]
GO
/****** Object:  ForeignKey [FK_Session_Local]    Script Date: 04/27/2009 20:49:24 ******/
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Session_Local]') AND parent_object_id = OBJECT_ID(N'[dbo].[Session]'))
ALTER TABLE [dbo].[Session] DROP CONSTRAINT [FK_Session_Local]
GO
/****** Object:  Table [dbo].[Inscription]    Script Date: 04/27/2009 20:49:11 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Inscription]') AND type in (N'U'))
DROP TABLE [dbo].[Inscription]
GO
/****** Object:  Table [dbo].[RapportEvaluation]    Script Date: 04/27/2009 20:49:20 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[RapportEvaluation]') AND type in (N'U'))
DROP TABLE [dbo].[RapportEvaluation]
GO
/****** Object:  Table [dbo].[REL_Article_ActeConference]    Script Date: 04/27/2009 20:49:21 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[REL_Article_ActeConference]') AND type in (N'U'))
DROP TABLE [dbo].[REL_Article_ActeConference]
GO
/****** Object:  Table [dbo].[Presentation]    Script Date: 04/27/2009 20:49:18 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Presentation]') AND type in (N'U'))
DROP TABLE [dbo].[Presentation]
GO
/****** Object:  Table [dbo].[Conference]    Script Date: 04/27/2009 20:49:09 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Conference]') AND type in (N'U'))
DROP TABLE [dbo].[Conference]
GO
/****** Object:  Table [dbo].[Local]    Script Date: 04/27/2009 20:49:13 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Local]') AND type in (N'U'))
DROP TABLE [dbo].[Local]
GO
/****** Object:  Table [dbo].[Participant]    Script Date: 04/27/2009 20:49:17 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Participant]') AND type in (N'U'))
DROP TABLE [dbo].[Participant]
GO
/****** Object:  Table [dbo].[Editeur]    Script Date: 04/27/2009 20:49:10 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Editeur]') AND type in (N'U'))
DROP TABLE [dbo].[Editeur]
GO
/****** Object:  Table [dbo].[Article]    Script Date: 04/27/2009 20:49:05 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Article]') AND type in (N'U'))
DROP TABLE [dbo].[Article]
GO
/****** Object:  Table [dbo].[ActeConference]    Script Date: 04/27/2009 20:49:02 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ActeConference]') AND type in (N'U'))
DROP TABLE [dbo].[ActeConference]
GO
/****** Object:  Table [dbo].[Session]    Script Date: 04/27/2009 20:49:24 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Session]') AND type in (N'U'))
DROP TABLE [dbo].[Session]
GO
/****** Object:  Table [dbo].[Local]    Script Date: 04/27/2009 20:49:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Local]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Local](
	[ID_Local] [int] IDENTITY(1,1) NOT NULL,
	[Numero] [varchar](50) NOT NULL,
	[Capacite] [int] NOT NULL,
 CONSTRAINT [PK_Local_1] PRIMARY KEY CLUSTERED 
(
	[ID_Local] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Conference]    Script Date: 04/27/2009 20:49:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Conference]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Conference](
	[ID_Conference] [int] IDENTITY(1,1) NOT NULL,
	[nom] [varchar](50) NOT NULL,
	[ville] [varchar](50) NOT NULL,
	[lieu] [varchar](50) NOT NULL,
	[maximumParticipant] [int] NOT NULL,
	[minimumParticipant] [int] NOT NULL,
	[dateDebut] [datetime] NOT NULL,
	[dateFin] [datetime] NOT NULL,
	[coutMinimal] [decimal](18, 2) NOT NULL,
	[dateLimiteInscription] [datetime] NOT NULL,
	[dateLimiteReceptionArticle] [datetime] NOT NULL,
	[dateLimiteRapportEvaluation] [datetime] NOT NULL,
	[dateLimiteReceptionArticleCorrige] [datetime] NOT NULL,
 CONSTRAINT [PK_Conference] PRIMARY KEY CLUSTERED 
(
	[ID_Conference] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Editeur]    Script Date: 04/27/2009 20:49:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Editeur]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Editeur](
	[ID_Editeur] [int] NOT NULL,
 CONSTRAINT [PK_Editeur] PRIMARY KEY CLUSTERED 
(
	[ID_Editeur] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[Participant]    Script Date: 04/27/2009 20:49:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Participant]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Participant](
	[NumeroParticipant] [int] IDENTITY(1,1) NOT NULL,
	[Titre] [varchar](50) NOT NULL,
	[Nom] [varchar](50) NOT NULL,
	[Prenom] [varchar](50) NOT NULL,
	[Statut] [varchar](50) NOT NULL,
	[Organisme] [varchar](50) NOT NULL,
	[Telephone] [varchar](50) NOT NULL,
	[Adresse] [varchar](50) NOT NULL,
	[Courriel] [varchar](50) NOT NULL,
	[Identifiant] [varchar](50) NOT NULL,
	[MotDePasse] [varchar](50) NOT NULL,
	[Specialite] [varchar](50) NULL,
	[TypeParticipant] [int] NOT NULL,
 CONSTRAINT [PK_Participant] PRIMARY KEY CLUSTERED 
(
	[NumeroParticipant] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Session]    Script Date: 04/27/2009 20:49:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Session]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Session](
	[ID_Session] [int] NOT NULL,
	[Titre] [varchar](50) NOT NULL,
	[DateHeureDebut] [datetime] NOT NULL,
	[DateHeureFin] [datetime] NOT NULL,
	[Tarif] [decimal](18, 2) NOT NULL,
	[ID_Conference] [int] NOT NULL,
	[ID_Local] [int] NOT NULL,
	[TypeSession] [int] NOT NULL,
 CONSTRAINT [PK_Session] PRIMARY KEY CLUSTERED 
(
	[ID_Session] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Presentation]    Script Date: 04/27/2009 20:49:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Presentation]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Presentation](
	[ID_Presentation] [int] IDENTITY(1,1) NOT NULL,
	[DateHeureDebut] [datetime] NOT NULL,
	[Duree] [timestamp] NOT NULL,
	[ID_Session] [int] NOT NULL,
 CONSTRAINT [PK_Presentation] PRIMARY KEY CLUSTERED 
(
	[ID_Presentation] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[REL_Article_ActeConference]    Script Date: 04/27/2009 20:49:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[REL_Article_ActeConference]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[REL_Article_ActeConference](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[ID_Article] [int] NOT NULL,
	[ID_Acte] [int] NOT NULL
) ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[RapportEvaluation]    Script Date: 04/27/2009 20:49:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[RapportEvaluation]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[RapportEvaluation](
	[ID_RapportEvaluation] [int] IDENTITY(1,1) NOT NULL,
	[ID_Article] [int] NOT NULL,
	[ID_Evaluateur] [int] NOT NULL,
	[Rapport] [varchar](max) NOT NULL,
	[Note] [int] NOT NULL,
 CONSTRAINT [PK_RapportEvaluation] PRIMARY KEY CLUSTERED 
(
	[ID_RapportEvaluation] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[Article]    Script Date: 04/27/2009 20:49:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Article]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Article](
	[ID_Article] [int] IDENTITY(1,1) NOT NULL,
	[Date] [datetime] NOT NULL,
	[Sujet] [varchar](50) NOT NULL,
	[Contenu] [varchar](max) NOT NULL,
	[ID_Auteur] [int] NOT NULL,
	[ID_Conference] [int] NOT NULL,
 CONSTRAINT [PK_Article] PRIMARY KEY CLUSTERED 
(
	[ID_Article] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Inscription]    Script Date: 04/27/2009 20:49:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Inscription]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Inscription](
	[ID_Inscription] [int] NOT NULL,
	[ID_Participant] [int] NOT NULL,
	[ID_Conference] [int] NOT NULL,
	[Montant] [decimal](18, 2) NOT NULL,
 CONSTRAINT [PK_Inscription] PRIMARY KEY CLUSTERED 
(
	[ID_Inscription] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[ActeConference]    Script Date: 04/27/2009 20:49:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ActeConference]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ActeConference](
	[ID_Acte] [int] IDENTITY(1,1) NOT NULL,
	[ID_Editeur] [int] NOT NULL,
 CONSTRAINT [PK_ActeConference] PRIMARY KEY CLUSTERED 
(
	[ID_Acte] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  ForeignKey [FK_ActeConference_Editeur]    Script Date: 04/27/2009 20:49:03 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ActeConference_Editeur]') AND parent_object_id = OBJECT_ID(N'[dbo].[ActeConference]'))
ALTER TABLE [dbo].[ActeConference]  WITH CHECK ADD  CONSTRAINT [FK_ActeConference_Editeur] FOREIGN KEY([ID_Editeur])
REFERENCES [dbo].[Editeur] ([ID_Editeur])
GO
ALTER TABLE [dbo].[ActeConference] CHECK CONSTRAINT [FK_ActeConference_Editeur]
GO
/****** Object:  ForeignKey [FK_Article_Conference1]    Script Date: 04/27/2009 20:49:05 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Article_Conference1]') AND parent_object_id = OBJECT_ID(N'[dbo].[Article]'))
ALTER TABLE [dbo].[Article]  WITH CHECK ADD  CONSTRAINT [FK_Article_Conference1] FOREIGN KEY([ID_Conference])
REFERENCES [dbo].[Conference] ([ID_Conference])
GO
ALTER TABLE [dbo].[Article] CHECK CONSTRAINT [FK_Article_Conference1]
GO
/****** Object:  ForeignKey [FK_Article_Participant]    Script Date: 04/27/2009 20:49:05 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Article_Participant]') AND parent_object_id = OBJECT_ID(N'[dbo].[Article]'))
ALTER TABLE [dbo].[Article]  WITH CHECK ADD  CONSTRAINT [FK_Article_Participant] FOREIGN KEY([ID_Auteur])
REFERENCES [dbo].[Participant] ([NumeroParticipant])
GO
ALTER TABLE [dbo].[Article] CHECK CONSTRAINT [FK_Article_Participant]
GO
/****** Object:  ForeignKey [FK_Inscription_Conference]    Script Date: 04/27/2009 20:49:11 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Inscription_Conference]') AND parent_object_id = OBJECT_ID(N'[dbo].[Inscription]'))
ALTER TABLE [dbo].[Inscription]  WITH CHECK ADD  CONSTRAINT [FK_Inscription_Conference] FOREIGN KEY([ID_Conference])
REFERENCES [dbo].[Conference] ([ID_Conference])
GO
ALTER TABLE [dbo].[Inscription] CHECK CONSTRAINT [FK_Inscription_Conference]
GO
/****** Object:  ForeignKey [FK_Inscription_Participant]    Script Date: 04/27/2009 20:49:11 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Inscription_Participant]') AND parent_object_id = OBJECT_ID(N'[dbo].[Inscription]'))
ALTER TABLE [dbo].[Inscription]  WITH CHECK ADD  CONSTRAINT [FK_Inscription_Participant] FOREIGN KEY([ID_Participant])
REFERENCES [dbo].[Participant] ([NumeroParticipant])
GO
ALTER TABLE [dbo].[Inscription] CHECK CONSTRAINT [FK_Inscription_Participant]
GO
/****** Object:  ForeignKey [FK_Presentation_Session]    Script Date: 04/27/2009 20:49:18 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Presentation_Session]') AND parent_object_id = OBJECT_ID(N'[dbo].[Presentation]'))
ALTER TABLE [dbo].[Presentation]  WITH CHECK ADD  CONSTRAINT [FK_Presentation_Session] FOREIGN KEY([ID_Session])
REFERENCES [dbo].[Session] ([ID_Session])
GO
ALTER TABLE [dbo].[Presentation] CHECK CONSTRAINT [FK_Presentation_Session]
GO
/****** Object:  ForeignKey [FK_RapportEvaluation_Article]    Script Date: 04/27/2009 20:49:20 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RapportEvaluation_Article]') AND parent_object_id = OBJECT_ID(N'[dbo].[RapportEvaluation]'))
ALTER TABLE [dbo].[RapportEvaluation]  WITH CHECK ADD  CONSTRAINT [FK_RapportEvaluation_Article] FOREIGN KEY([ID_Article])
REFERENCES [dbo].[Article] ([ID_Article])
GO
ALTER TABLE [dbo].[RapportEvaluation] CHECK CONSTRAINT [FK_RapportEvaluation_Article]
GO
/****** Object:  ForeignKey [FK_RapportEvaluation_Participant]    Script Date: 04/27/2009 20:49:20 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RapportEvaluation_Participant]') AND parent_object_id = OBJECT_ID(N'[dbo].[RapportEvaluation]'))
ALTER TABLE [dbo].[RapportEvaluation]  WITH CHECK ADD  CONSTRAINT [FK_RapportEvaluation_Participant] FOREIGN KEY([ID_Evaluateur])
REFERENCES [dbo].[Participant] ([NumeroParticipant])
GO
ALTER TABLE [dbo].[RapportEvaluation] CHECK CONSTRAINT [FK_RapportEvaluation_Participant]
GO
/****** Object:  ForeignKey [FK_REL_Article_ActeConference_ActeConference]    Script Date: 04/27/2009 20:49:21 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_REL_Article_ActeConference_ActeConference]') AND parent_object_id = OBJECT_ID(N'[dbo].[REL_Article_ActeConference]'))
ALTER TABLE [dbo].[REL_Article_ActeConference]  WITH CHECK ADD  CONSTRAINT [FK_REL_Article_ActeConference_ActeConference] FOREIGN KEY([ID_Acte])
REFERENCES [dbo].[ActeConference] ([ID_Acte])
GO
ALTER TABLE [dbo].[REL_Article_ActeConference] CHECK CONSTRAINT [FK_REL_Article_ActeConference_ActeConference]
GO
/****** Object:  ForeignKey [FK_REL_Article_ActeConference_Article]    Script Date: 04/27/2009 20:49:21 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_REL_Article_ActeConference_Article]') AND parent_object_id = OBJECT_ID(N'[dbo].[REL_Article_ActeConference]'))
ALTER TABLE [dbo].[REL_Article_ActeConference]  WITH CHECK ADD  CONSTRAINT [FK_REL_Article_ActeConference_Article] FOREIGN KEY([ID_Article])
REFERENCES [dbo].[Article] ([ID_Article])
GO
ALTER TABLE [dbo].[REL_Article_ActeConference] CHECK CONSTRAINT [FK_REL_Article_ActeConference_Article]
GO
/****** Object:  ForeignKey [FK_Session_Conference]    Script Date: 04/27/2009 20:49:24 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Session_Conference]') AND parent_object_id = OBJECT_ID(N'[dbo].[Session]'))
ALTER TABLE [dbo].[Session]  WITH CHECK ADD  CONSTRAINT [FK_Session_Conference] FOREIGN KEY([ID_Conference])
REFERENCES [dbo].[Conference] ([ID_Conference])
GO
ALTER TABLE [dbo].[Session] CHECK CONSTRAINT [FK_Session_Conference]
GO
/****** Object:  ForeignKey [FK_Session_Local]    Script Date: 04/27/2009 20:49:24 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Session_Local]') AND parent_object_id = OBJECT_ID(N'[dbo].[Session]'))
ALTER TABLE [dbo].[Session]  WITH CHECK ADD  CONSTRAINT [FK_Session_Local] FOREIGN KEY([ID_Local])
REFERENCES [dbo].[Local] ([ID_Local])
GO
ALTER TABLE [dbo].[Session] CHECK CONSTRAINT [FK_Session_Local]
GO
